5 Reasons why XLookups are Better than VLookups
If you learned VLookup to do your table consolidations, you need to check out the new XLookup functi ...View More
Using Index and Match Functions in Excel to Derive a Value from a Matrix Table
This video provides step-by-step instructions on how to leverage the Index and Match functions withi ...View More
Excel Pivots in 10 Minutes
Learn to use Excel Pivot tables and how to manipulate the data in under ten minutes. Agenda Introduc ...View More
Why is my V-lookup Not Working?
Have you ever tried to create a v-lookup in Excel, only to have it give you errors. This video discu ...View More
V Lookups Made Easy
Learn the basics of successful V-Lookups in Microsoft Excel. This video walks through the basics in ...View More
How I saved days of work by using VBA for Excel to break out my spreadsheets (A how to video)
In this video, I provide a step-by-step demonstration of how to take a master excel report and break ...View More
Build your own FLSA Evaluation Tool and save $10,000's
In this video, I walk you through the tools free, or readily available resources you can use to buil ...View More
Team Effectiveness
Team Effectiveness focuses on team excellence or the desired outcomes of teamwork. Two critical func ...View More
How To Use Machine Learning To Predict Candidate Compatibility
We are screen sharing and teaching you how to use the free Boolean Builder and how to build automati ...View More
Day 10: Share your knowledge with others
Teaching others is an excellent way to learn more about a subject. Seek out an opportunity to teach ...View More